Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _
"GetOpenFileNameA" (pOpenfilename As OpenFileName) As Long
Private Declare Function GetSaveFileName Lib "comdlg32.dll" _
Alias "GetSaveFileNameA" (pOpenfilename As OpenFileName) As Long
Public Enum FilterType
fText = 0
fDatabase = 1
fExcel = 2
fSystem = 3
fCustom = 4
End Enum
Public Function OpenDialogBox(FormName As Form, Filter As FilterType, Optional InitialDir As String, Optional DialogTitle As String, Optional CustomFilter As String) As String
'
Dim ofn As OpenFileName, a
Dim strInitDir As String, dlgTitle As String
Dim strFilter
'
If Not IsEmpty(InitialDir) Then
strInitDir = InitialDir
Else
strInitDir = CurDir
End If
'
If Not IsEmpty(DialogTitle) Then
dlgTitle = DialogTitle
Else
dlgTitle = "Open"
End If
'
If IsEmpty(CustomFilter) And Filter = fCustom Then